How to Convert Excel to CSV

CSV format is another file format used for keeping tabular data. Unlike Excel .xlsx format, this format keeps tabular data as plain text. The main difference between Excel xlsx and CSV files is formatting. Excel xlsx files have formatting features you can use to present data in a visually compelling way. CSV file type doesn’t keep any formatting, just text in its simplest form. The biggest reason why csv files are used is the fact they can be opened in every application and text editor.


In this article, we will show you how to export data from Excel to CSV and how to convert Excel to CSV keeping all special characters and foreign symbols intact. The following solutions work for all versions of Excel 2016, 2013, 2010 and 2007.

What is the first step to convert Excel to CSV?

  1. Open your Excel spreadsheet and click on File menu, and then on Save As.

 

Have in mind, if your Excel spreadsheet contains more than one sheet, only the current sheet will be converted to CSV. If you want to convert all sheets to CSV, you need to save each sheet as a separate Excel (xlsx file).

convert excel to csv

To create a new Excel file from every sheet separately, right click on the sheet and then click on Move or Copy. In the field To book, select a new book. Click OK. In that way you can create a separate workbook from any sheet.

Save as CSV File

excel to csv

  1. The second step is to choose the file type in the field Save as type. You need to find and select CSV UTF-8 (Comma Delimited).

 

  1. The third and alternative step is to rename the file. Otherwise, save it with default name. Finally click the Save button.

Note: always check the location where your file will be saved so it gets easier to find the file when you need it.

 

Another thing to have in mind, in the latest versions of Excel, when you go to Save as option, you need to select the location where you want to save the file and then the Save as dialog will appear.

Do you want to keep unsupported features?

 

When you hit the Save button, it is possible that the error dialog will pop up. In case your workbook contains multiple sheets, you will be notified that only the current sheet will be saved as csv.

 

Since Excel files have formatting features that cannot be preserved in CSV, you will be notified about this changes. Simply click YES to confirm these changes.

5 Tools that Could Change the Way you Manage your Business

No matter what kind of business do you run, you probably rely on technology in every aspect of business management. There are a lot of tools that are built to help businesses complete their projects and daily activities. With so many tools around, it is hard to keep track of all of them. Assuming that you are probably busy with your everyday duties, you don’t even have time to search for new tools and test them.

Fortunately, many blogs including ours provide their readers with such information and give tools suggestions. If your goal is to improve your business you should think of increasing efficiency and collaboration, advancing data security, data analysis and file management.

Improve data analysis, data collection, file management

domo

  1. Domo is a unique way to run your business because it can bring your data together. It even has a real-time data refresh which means all your data is synced. Domo has data connectors which you can connect to directly. In other words, you can access all your cloud applications, spreadsheets, files. Domo makes your data analysis easier.

     2. Easely is a tool for making infographics. If your designer is busy and you need quick designs, Easily offers a wide range of templates that you can choose from and have your infographic ready in a few hours. You need it for better efficiency.

create infographics

3. Web Harvest is data scraper which extracts data from the web and gives you an option to email it or save it to a database. It allows you to apply the variety of data manipulation techniques. The whole research process is much quicker and better organized.

4. ShieldSquare is a data protection tool that protects your business from spam, account takeover, skewed analytics, digital ad fraud, price and content scraping. It fights bots successfully and protects your online business.  

shield square

5. Cometdocs is all-in-on document management tool. You can use it to store files, transfer files to other people and computers, convert PDF files to various file formats, and even host files. Cometdocs offers PDF to Word, PDF to Excel, PPT, Image and other conversion types.

With help of these five different tools you can improve file management (Cometdocs), protect business data (Shield Square), increase content efficiency (Ease.ly), analyze data quicker (Domo), collect data (Web Harvest). All these things mentioned, can change the way you manage your business and help you gain more success.

 

Convert PDF to Word Online Free with Cometdocs

Those who deal with PDF files know how important can be PDF to Word conversion. PDF files are great when you need to upload  or send a document somewhere else because they keep the document format. But on the other hand, it is widely known that PDF files are hard to edit and the easiest way to do that is to convert PDF files to Word or other editable formats. In case you didn’t know or you just forget, you can convert PDF to Word online free right here on Cometdocs.

 

What is Cometdocs?

Cometdocs is a file converter that converts files from one format to another. It works online and you don’t need to install anything on your computer. On the top of that it’s free. If you want to use this file converter free, you can just upload files here and choose the conversion type.

 

Not only can you convert files for free, but you can also use Transfer option to send a file to someone else.

transfer files online

 

As you assume from the image above, you just need to click the Transfer tab, drag the uploaded file in the first box, type a recipient email and your email as well. You can send the  original file that you uploaded on Cometdocs, or the converted version.

 

As for uploading files, you can upload files from your computer or from Google Drive or Dropbox. In that case, you need to sign in your Gmail account. Read more

iPhone Attempting Data Recovery – Will your data be saved?

If you are an iPhone user, you’ve probably experienced or heard at least once about this scary message “ attempting data recovery ”. This error message shows up when you want to upgrade to the latest version of iOS software (on iPhone or iPad). It usually appears when you update iOS via iTunes. So, if you want to avoid seeing this error, you can update iOS wirelessly. However, if you prefer to update your iOS device via iTunes, don’t get surprised if you see this error message “ attempting data recovery ”. This message usually appears on iPhone X/8/7/6s/6, for the iOS versions 11.2/11.1/11/10. If you see this message on your iOS device, don’t panic and be patient. It takes some time to recover all the data.

attempting data recovery

 

What can possibly go wrong?

Unfortunately, it may happen that your phone or tablet is stuck with that message or that the device is not recovered. In other words, all data or some data can disappear. So if you have a bad luck and your data is not (completely) saved, here are a few tips for solving the issue or preventing the issue to happen.

If your iPhone or iPad is stuck, you can try to restart it. On iPhone 6 and 6 plus, press the Home and the Power button. On iPhone 7 and 7 plus, press the power key and the volume down key at the same time. Hold it until the device is not restarted. On iPhone 8 and iPhone X, press and hold the power button.

 

Backup your data via iTunes or iCloud

 

If you regularly back up your data on iTunes or iCloud, the data loss won’t be a problem at all. In that case, you just need to recover data from iTunes backup file.

The process is very simple, tap on the Settings and then on iCloud. Now tap on Backup by doing so, the backup data will reappear. If you haven’t done it already, now it’s right time to do it- let iCloud backup data automatically.

If you want to backup with iTunes, connect your iPhone or iPad to your computer. Open the iTunes and click the Back Up Now. If you happen to lose your data, you can always click on the Restore Backup.

 

You didn’t backup on time and the data is lost

 

If you had a bad luck and after updating iOS, the message “ attempting data recovery ” appeared resulting in data loss, the first thing you can try is to restart your phone as we explained above. Restoring backup files doesn’t help if you didn’t set backup option previously.

In that case, you can try one of these data backup tools such as MiniTool and iMobie. These tools help you recover deleted files from your device. But there is one thing you need to know- data recovery tools cannot recover the lost data if new data overwrites them.

So, if this problem occurs don’t use the phone until the data is restored.

How to Move Pictures to SD Card

Mobile phones are mostly used to take photos and not so many people take real professional cameras with them. Every average mobile device has a decent camera and people just find it easier to use phone’s camera instead of bringing an additional gadget. The problem occurs when after some time you get too many photos in your phone and it just starts to malfunction. If you use your phone camera to take photos, you’ve probably experienced at least once in your lifetime that your phone memory is overloaded. Today we will show you how to move pictures to SD card and take off that burden from your phone.

how to move pictures to sd card

 

What are sd cards?

 

SD cards are actually an additional memory and some phones already have them by default. Phones with sd cards, or at least sd card slot, are very good because you can always change that sd card and buy one with bigger space on it.

Have in mind however that your phone cannot support sd card of every size. Every mobile device has its limit so before buying an sd card, get informed about your phone’s limits.

 

Where are pictures stored when you take a shot?

 

Usually it is set up by default to store pictures on the phone memory, on the device storage in the pictures folder. But pictures can be automatically stored in sd card if you change the settings. Anyway, if you didn’t set this up and you have been struggling with the full memory on the phone, the only thing to do is move pictures to sd card.

Unfortunately, not all types of phones have the exactly same process of transferring photos and files to sd card. So you need to learn how to move pictures to sd card for your specific type of phone. The difference is not huge and even though you don’t find the guide below that corresponds to your phone, the steps should be similar.

 

How to move pictures to sd card on Samsung Galaxy

 

Go to Apps and find the folder called My Files. From the options select want you want to move, in this case, images. Select the menu icon which looks like this=>

First tap on Edit and then tap on all pictures you want to move. The selected pictures would have the check mark. Again, tap on and then on Move. Finally, tap on sd card. If you have multiple folders in your sd card, select the preferred folder and tap Done (on some phones it is Move here).

 

How to move pictures to sd card by using usb cable

 

This is one of the easiest ways and it should work on all mobile devices. But you need a computer for this purpose and a usb cable. With that cable you will connect your phone to your PC or Mac.  In some cases, you will need to tap on the phone to choose the option different from Charge only. In other cases, the window will pop up automatically and you just need to open the main folder that leads to your phone content.  Internal storage of your phone and the sd card should be seen as two different folders. You simply need to copy pictures from the internal storage and paste them in the sd card folder.

 

Move pictures to sd card with file manager apps

 

There are many file manager apps that make this whole process of transferring files much easier. Some phones already have file managers installed by default. If your phone doesn’t have such app, you can visit the app store or Google play store and search for “file manager” app. Most of these file manager apps are free to use, and the steps are very simple. It usually comes down to choosing multi select option to mark multiple images and then tapping on Move option and finding SD Card as a “move to” option.

 

Moving pictures to sd cards (on mobile phones other than Samsung)

 

In generally, every smartphone has a similar icon for Settings option, in the shape of gear. Tap on it and find Device and Storage option. It is not always called like this, but usually Storage is mentioned. Find the internal storage option and tap on Images. If you want to move pictures taken by your camera, go to Camera folder. If you use Viber, Instagram, Facebook you probably have folders in those names, because all pictures saved from these apps are kept in separate folders. You can move pictures from these folders in the same way.

If you want to move all the pictures, you can either select the folder or tap on and then Select all. To select only specific pictures, tap on each picture once. The next step is to tap on Move to, on some devices it is known as Copy to, or simply Move. Now tap on your sd card and again on the specific folder in your sd card, where you want to move photos to. If you don’t have a folder, you can create it. Finally, tap on the button Copy/Move/Done, depending on the phone you use.