Import or export a spreadsheet as CSV
Make a spreadsheet from a CSV or TSV file, bring in an Excel or Google Sheets file, and download a sheet as CSV.
Import a CSV or TSV file
Select Import on the Spreadsheets page to create a spreadsheet from a CSV or TSV file. To bring in an Excel or Google Sheets file, save or download it as CSV first.
- Magpie detects comma, tab or semicolon separators, or you can choose one.
- Files saved by Excel as CSV UTF-8, CSV or Unicode Text keep their accented letters and symbols.
- A file can be up to 5 MB, 100,000 rows, 1,000 columns and 1,000,000 cells.
Export a sheet as CSV
Choose File → Export CSV, or press Ctrl/⌘ E, to download the sheet you are on. A CSV file holds one sheet, so export each sheet separately.
Magpie first saves your latest changes and the results of the formulas that use them. If your changes cannot be saved yet, the export waits and says so, rather than download a file without them.
A formula cell exports its last calculated result: if inputs were changed only in the mobile app or by the assistant, open the spreadsheet on the website before you export, so the results are calculated again. Values that another spreadsheet program would read as a formula are written with a leading apostrophe.
If a file will not import, or an export is missing values, Contacter l’assistance.
Demander à l’assistance Magpie
Envoyez à l’équipe Magpie une question sur tout ce que cet article n’explique pas.