I can't find any information on this here or in the manual.
I'd like importing to work like this:
Select a cell (say A200).
Go to menu item - File- Import (does not currently exist)
This would open a Windows file chooser window
Select the CSV file.
Go through the existing "open CSV" dialog and make your choices - no need to change widths, data types or specify a headings row.
The CSV would import beginning at selected cell (eg A200).
Column widths, data types (date, currency etc) would be retained from the spreadsheet. Think of the CSV being merged with the existing spreadsheet.
If the first row of the CSV contained headings, they would be treated like normal data. You could delete the heading row after importing if you didn't want them.
If the selected cell (A200) wasn't at the end of the sheet, rows would automatically be inserted to accommodate the CSV.
At the moment, unless I've missed something, this doesn't seem possible in Planmaker 2021.
The current workaround is to open the CSV in a new sheet, insert enough rows in the existing sheet to accommodate the CSV data if it's not being added at the end, then copy-paste the data into the existing sheet, then delete the new sheet.
Importing would be nice!
Also nice would be, when you choose "insert cells" to insert rows, a dialog that enabled you to specify how many rows you wanted to insert. (Same for columns). The current method echoes Excel, but it is fairly clumsy, relying as it does on powers of 2 to insert multiple rows.
cheers
Holo
Import CSV into existing spreadsheet
-
- Posts: 6
- Joined: Fri Apr 23, 2010 12:52 am
Post Reply
2 posts
• Page 1 of 1
Return to “PlanMaker 2021 for Windows”
Jump to
- SoftMaker Office NX and 2024
- ↳ SoftMaker Office NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Windows (General)
- ↳ TextMaker NX and 2024 for Windows
- ↳ PlanMaker NX and 2024 for Windows
- ↳ Presentations NX and 2024 for Windows
- ↳ BasicMaker NX and 2024 for Windows
- ↳ SoftMaker Office NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Mac (General)
- ↳ TextMaker NX and 2024 for Mac
- ↳ PlanMaker NX and 2024 for Mac
- ↳ Presentations NX and 2024 for Mac
- ↳ SoftMaker Office NX and 2024 for Linux
- ↳ SoftMaker Office NX and 2024 for Linux (General)
- ↳ TextMaker NX and 2024 for Linux
- ↳ PlanMaker NX and 2024 for Linux
- ↳ Presentations NX and 2024 for Linux
- ↳ SoftMaker Office NX for iOS
- ↳ SoftMaker Office NX for iOS (General)
- ↳ TextMaker NX for iOS
- ↳ PlanMaker NX for iOS
- ↳ Presentations NX for iOS
- ↳ SoftMaker Office NX for Android
- ↳ SoftMaker Office NX for Android (General)
- ↳ TextMaker NX for Android
- ↳ PlanMaker NX for Android
- ↳ Presentations NX for Android
- SoftMaker Office 2021
- ↳ SoftMaker Office 2021 for Windows
- ↳ SoftMaker Office 2021 for Windows (General)
- ↳ TextMaker 2021 for Windows
- ↳ PlanMaker 2021 for Windows
- ↳ Presentations 2021 for Windows
- ↳ BasicMaker 2021 for Windows
- ↳ SoftMaker Office 2021 for Mac
- ↳ SoftMaker Office 2021 for Mac (General)
- ↳ TextMaker 2021 for Mac
- ↳ PlanMaker 2021 for Mac
- ↳ Presentations 2021 for Mac
- ↳ SoftMaker Office 2021 for Linux
- ↳ SoftMaker Office 2021 for Linux (General)
- ↳ TextMaker 2021 for Linux
- ↳ PlanMaker 2021 for Linux
- ↳ Presentations 2021 for Linux
- FreeOffice 2024
- ↳ FreeOffice 2024 for Windows
- ↳ FreeOffice 2024 for Windows (General)
- ↳ FreeOffice TextMaker 2024 for Windows
- ↳ FreeOffice PlanMaker 2024 for Windows
- ↳ FreeOffice Presentations 2024 for Windows
- ↳ FreeOffice 2024 for Mac
- ↳ FreeOffice 2024 for Mac (General)
- ↳ FreeOffice TextMaker 2024 for Mac
- ↳ FreeOffice PlanMaker 2024 for Mac
- ↳ FreeOffice Presentations 2024 for Mac
- ↳ FreeOffice 2024 for Linux
- ↳ FreeOffice 2024 for Linux (General)
- ↳ FreeOffice TextMaker 2024 for Linux
- ↳ FreeOffice PlanMaker 2024 for Linux
- ↳ FreeOffice Presentations 2024 for Linux
- ↳ FlexiPDF NX and 2025 for Windows
- ↳ FlexiPDF 2022
- ↳ FreePDF 2022
- Miscellaneous
- ↳ SoftMaker Fonts
- ↳ Water Cooler
- ↳ SoftMaker Office 2018 for Windows (General)
- ↳ TextMaker 2018 for Windows
- ↳ PlanMaker 2018 for Windows
- ↳ Presentations 2018 for Windows
- ↳ Thunderbird for Windows
- ↳ BasicMaker 2018 for Windows
- ↳ SoftMaker Office 2018 for Mac (General)
- ↳ TextMaker 2018 for Mac
- ↳ PlanMaker 2018 for Mac
- ↳ Presentations 2018 for Mac
- ↳ SoftMaker Office 2018 for Linux (General)
- ↳ TextMaker 2018 for Linux
- ↳ PlanMaker 2018 for Linux
- ↳ Presentations 2018 for Linux
- ↳ FreeOffice 2021
- ↳ FreeOffice 2021 for Windows
- ↳ FreeOffice 2021 for Windows (General)
- ↳ FreeOffice TextMaker 2021 for Windows
- ↳ FreeOffice PlanMaker 2021 for Windows
- ↳ FreeOffice Presentations 2021 for Windows
- ↳ FreeOffice 2021 for Mac
- ↳ FreeOffice 2021 for Mac (General)
- ↳ FreeOffice TextMaker 2021 for Mac
- ↳ FreeOffice PlanMaker 2021 for Mac
- ↳ FreeOffice Presentations 2021 for Mac
- ↳ FreeOffice 2021 for Linux
- ↳ FreeOffice 2021 for Linux (General)
- ↳ FreeOffice TextMaker 2021 for Linux
- ↳ FreeOffice PlanMaker 2021 for Linux
- ↳ FreeOffice Presentations 2021 for Linux
- ↳ BETA SoftMaker Office 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Windows (general)
- ↳ BETA TextMaker 2024 for Windows
- ↳ BETA PlanMaker 2024 for Windows
- ↳ BETA Presentations 2024 for Windows
- ↳ BETA BasicMaker 2024 for Windows
- ↳ BETA SoftMaker Office 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Mac (general)
- ↳ BETA TextMaker 2024 for Mac
- ↳ BETA PlanMaker 2024 for Mac
- ↳ BETA Presentations 2024 for Mac
- ↳ BETA SoftMaker Office 2024 for Linux
- ↳ BETA SoftMaker Office 2024 for Linux (general)
- ↳ BETA TextMaker 2024 for Linux
- ↳ BETA PlanMaker 2024 for Linux
- ↳ BETA Presentations 2024 for Linux
- ↳ BETA SoftMaker Office NX for Android
- ↳ BETA SoftMaker Office NX for Android (general)
- ↳ BETA TextMaker NX for Android
- ↳ BETA PlanMaker NX for Android
- ↳ BETA Presentations NX for Android
- ↳ BETA SoftMaker Office NX for iOS
- ↳ BETA SoftMaker Office NX for iOS (general)
- ↳ BETA TextMaker NX for iOS
- ↳ BETA PlanMaker NX for iOS
- ↳ BETA Presentations NX for iOS
- ↳ SoftMaker Office 2021 for Android
- ↳ SoftMaker Office 2021 for Android (General)
- ↳ TextMaker 2021 for Android
- ↳ PlanMaker 2021 for Android
- ↳ Presentations 2021 for Android
- ↳ SoftMaker Office 2021 for iOS
- ↳ General
- ↳ TextMaker 2021 for iOS
- ↳ PlanMaker 2021 for iOS
- ↳ Presentations 2021 for iOS