Ledgy lets you export all your data as CSV files. Here’s a step-by-step guide to import CSV with all special characters and numbers well-formatted.
Ledgy lets you export all your data as CSV files. You might be thinking “Well great, but I hate all the formatting problems when opening CSV in Excel or Google Sheets”. Don’t worry we’ve thought about this and here’s a step-by-step guide to import CSV with all special characters and numbers well-formatted.
To open your CSV file optimally in Microsoft Excel or Google Sheets you need to make sure that
UTF-8
.
,
Data
menu click on From Text
.Delimited — Characters such as commas or tabs separate each field
. Click on next.Advanced…
and set decimal separator to dot .
and thousands separator to a comma ,
.File
→ Import
. Choose the Upload tab and upload your CSV file.Import data
and you’re done.With a score of 4 against 7 setup steps, Google does a better job than Microsoft to import CSV files 😃
or