{"id":1317,"date":"2020-03-26T13:40:11","date_gmt":"2020-03-26T13:40:11","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=1317"},"modified":"2021-07-23T12:28:43","modified_gmt":"2021-07-23T12:28:43","slug":"como-exportar-dados-para-o-excel","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel","title":{"rendered":"4 truques f\u00e1ceis para exportar dados para o Excel"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\"><strong>Resumo:<\/strong> este tutorial ajudar\u00e1 todos dentro explorando seu conhecimento sobre como <strong>exportar dados para o Excel<\/strong>. Este artigo aborda quatro maneiras poss\u00edveis de <strong>exportar dados para o Excel<\/strong> e tamb\u00e9m fornece algumas dicas f\u00e1ceis para solucionar problemas encountred enquanto isso executando esse processo.<!--more--><\/p>\n<h2 style=\"text-align: center;\"><strong><u>Como\u00a0Para\u00a0exportar dados para o Excel<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">D\u00ea uma olhada r\u00e1pida nos diferentes m\u00e9todos que discutiremos para\u00a0<strong>exportar dados\u00a0para o\u00a0Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>M\u00e9todo # 1: Usando o Assistente de Exporta\u00e7\u00e3o<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>M\u00e9todo # 2: Exportando dados\u00a0para o\u00a0Excel de um bot\u00e3o<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>M\u00e9todo 3 # Exportando dados do relat\u00f3rio\u00a0para o\u00a0Excel<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><em>M\u00e9todo 4 # Exportar dados SQL\u00a0para o\u00a0Excel<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\"><em>Vamos\u00a0falar\u00a0sobre todos esses m\u00e9todos em detalhes &#8230;.!\u00a0<\/em><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo # 1: Usando o Assistente de Exporta\u00e7\u00e3o<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">Em nosso primeiro m\u00e9todo, aprenderemos a\u00a0<strong>exportar dados para o Excel\u00a0<\/strong>usando o\u00a0<strong>assistente de Exporta\u00e7\u00e3o\u00a0<\/strong>.\u00a0Aqui vamos considerar a\u00a0<strong>exporta\u00e7\u00e3o de dados do Access para o Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong><u>Etapas\u00a0para\u00a0exportar dados de Access para o Excel usando o Assistente de Exporta\u00e7\u00e3o<\/u><\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1300\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-access-data-to-excel.png\" alt=\"Usando o Assistente de Exporta\u00e7\u00e3o\" width=\"401\" height=\"226\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-access-data-to-excel.png 750w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-access-data-to-excel-300x169.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<ol style=\"text-align: justify;\">\n<li>Antes de tudo, feche a pasta de trabalho do Excel aberta anteriormente antes de iniciar o processo de exporta\u00e7\u00e3o.<\/li>\n<li>Agora v\u00e1 para o painel de navega\u00e7\u00e3o do banco de dados de origem do Access e fa\u00e7a uma sele\u00e7\u00e3o do objeto que voc\u00ea precisa exportar.<\/li>\n<li>Toque na\u00a0guia\u00a0Dados Externos\u00a0e depois v\u00e1 para o grupo de exporta\u00e7\u00e3o.\u00a0Nesse grupo, clique no\u00a0\u00edcone\u00a0do\u00a0Excel\u00a0.<\/li>\n<li>Depois disso, voc\u00ea ver\u00e1 que na tela \u00e9 exibida uma caixa de di\u00e1logo\u00a0Exportar &#8211;\u00a0Planilha do\u00a0Excel\u00a0.\u00a0Atribua um nome de arquivo para sua pasta de trabalho do Excel.\u00a0Geralmente, o Access faz uso do nome do objeto de origem.\u00a0Se voc\u00ea estiver disposto a modific\u00e1-lo, poder\u00e1 faz\u00ea-lo.<\/li>\n<li>Agora, na caixa\u00a0Formato\u00a0do\u00a0arquivo\u00a0, escolha o formato que voc\u00ea precisa.<\/li>\n<li>Suponha que voc\u00ea esteja se aproximando para exportar consulta ou tabela.\u00a0Al\u00e9m disso, se voc\u00ea deseja exportar os dados formatados, escolha a op\u00e7\u00e3o\u00a0Exportar dados com formata\u00e7\u00e3o e layout\u00a0.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong>Nota:\u00a0<\/strong>no momento da exporta\u00e7\u00e3o do relat\u00f3rio ou formul\u00e1rio, esta op\u00e7\u00e3o de\u00a0Exportar dados com formata\u00e7\u00e3o e layout\u00a0parece indispon\u00edvel ou esmaecida para voc\u00ea.<\/p>\n<ol style=\"text-align: justify;\" start=\"7\">\n<li>Se voc\u00ea deseja que sua planilha do Excel de destino seja aberta automaticamente ap\u00f3s o processo de exporta\u00e7\u00e3o.\u00a0Basta colocar um sinal de verifica\u00e7\u00e3o no campo &#8221;\u00a0Abrir o arquivo de destino ap\u00f3s a conclus\u00e3o da opera\u00e7\u00e3o de exporta\u00e7\u00e3o&#8221;<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Se os objetos de origem j\u00e1 estiverem abertos ou na exibi\u00e7\u00e3o, voc\u00ea selecionou um ou v\u00e1rios registros antes do in\u00edcio do procedimento de exporta\u00e7\u00e3o.\u00a0Depois, voc\u00ea pode escolher a op\u00e7\u00e3o\u00a0&#8220;Exportar apenas os registros selecionados&#8221;\u00a0.<\/p>\n<p style=\"text-align: justify;\">Mas, para exportar todo o seu registro presente na exibi\u00e7\u00e3o, voc\u00ea deve deixar a\u00a0caixa de sele\u00e7\u00e3o\u00a0Exportar apenas os registros selecionados\u00a0vazia.<\/p>\n<p style=\"text-align: justify;\">Observa\u00e7\u00e3o:\u00a0a\u00a0caixa de sele\u00e7\u00e3o\u00a0Exportar somente os registros selecionados\u00a0parece indispon\u00edvel para voc\u00ea se nenhum registro for escolhido.<\/p>\n<ol style=\"text-align: justify;\" start=\"8\">\n<li>Toque na\u00a0op\u00e7\u00e3o\u00a0OK\u00a0.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Se, infelizmente, os\u00a0dados de exporta\u00e7\u00e3o para o\u00a0processo\u00a0do Excel\u00a0falharem devido a algum erro, o aplicativo Access emitir\u00e1 uma mensagem sobre a causa do erro de exporta\u00e7\u00e3o.<\/p>\n<p style=\"text-align: justify;\">Se nenhum erro for encontrado, a tarefa de exportar\u00a0dados do Access para o Excel ser\u00e1 bem-sucedida.\u00a0E automaticamente a pasta de trabalho do Excel de destino ap\u00f3s a exporta\u00e7\u00e3o ser aberta na tela.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo # 2: Exportando dados\u00a0para o\u00a0Excel de um bot\u00e3o<\/u><\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1301\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-dat-to-excel-using-button.png\" alt=\"Exportando dados\u00a0para o\u00a0Excel de um bot\u00e3o\" width=\"512\" height=\"288\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-dat-to-excel-using-button.png 512w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-dat-to-excel-using-button-300x169.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/p>\n<p style=\"text-align: justify;\">Nosso segundo m\u00e9todo de\u00a0<strong>exporta\u00e7\u00e3o de dados para o Excel a\u00a0partir de um bot\u00e3o\u00a0<\/strong>\u00e9 bastante r\u00e1pido e automatizado para obter resultados rapidamente no Excel.<\/p>\n<p style=\"text-align: justify;\"><strong>Nota :<\/strong><\/p>\n<p style=\"text-align: justify;\">A execu\u00e7\u00e3o desse m\u00e9todo remover\u00e1 os zeros \u00e0 esquerda porque os dados s\u00e3o exportados do conjunto de resultados.\u00a0Portanto, voc\u00ea receber\u00e1 apenas os dados brutos, excluindo subtotais ou colunas do relat\u00f3rio.<\/p>\n<ol style=\"text-align: justify;\">\n<li>Antes de tudo, visite a\u00a0Janela de consultas\u00a0do\u00a0usu\u00e1rio\u00a0e, agora, no\u00a0menu\u00a0Ferramentas\u00a0, fa\u00e7a uma sele\u00e7\u00e3o para o\u00a0&#8220;Modo Design&#8221;\u00a0ou apenas toque no bot\u00e3o &#8220;Modo Design&#8221;.<\/li>\n<li>Clique com o bot\u00e3o direito do mouse na se\u00e7\u00e3o Janela, onde voc\u00ea deve colocar o bot\u00e3o primeiro.\u00a0Ou, no menu de atalho, toque na op\u00e7\u00e3o\u00a0&#8220;Criar bot\u00e3o &#8230;&#8221;\u00a0.<\/li>\n<li>Depois, toque no bot\u00e3o &#8220;Editar texto&#8221; op\u00e7\u00e3o.\u00a0Aqui voc\u00ea pode atribuir um nome ao bot\u00e3o e tamb\u00e9m pode formatar o bot\u00e3o de exibi\u00e7\u00e3o.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Usando o\u00a0bot\u00e3o da\u00a0cor\u00a0esquerda\u00a0, voc\u00ea pode fazer altera\u00e7\u00f5es na\u00a0cor\u00a0do texto,\u00a0enquanto usando o\u00a0bot\u00e3o da\u00a0cor\u00a0certa\u00a0, voc\u00ea pode modificar a\u00a0cor\u00a0do plano de fundo\u00a0.\u00a0Depois de concluir todas\u00a0as\u00a0tarefas, toque na op\u00e7\u00e3o OK presente nesta caixa de di\u00e1logo aberta do\u00a0texto\u00a0de\u00a0edi\u00e7\u00e3o\u00a0.<\/p>\n<ol style=\"text-align: justify;\" start=\"4\">\n<li>Agora, na lista suspensa presente na se\u00e7\u00e3o\u00a0&#8220;Link para&#8221;\u00a0, fa\u00e7a uma sele\u00e7\u00e3o para a consulta que voc\u00ea deseja executar atrav\u00e9s do bot\u00e3o.<\/li>\n<li>Na se\u00e7\u00e3o\u00a0&#8220;Sa\u00edda para&#8221;,\u00a0voc\u00ea precisa escolher o\u00a0bot\u00e3o\u00a0&#8220;Aplicativo&#8221;\u00a0.<\/li>\n<li>Quando todas as coisas acima estiverem conclu\u00eddas, basta tocar no\u00a0bot\u00e3o\u00a0[OK]\u00a0presente na\u00a0caixa de di\u00e1logo\u00a0Criar bot\u00e3o\u00a0.<\/li>\n<li>Agora \u00e9 hora de sair do modo Design.\u00a0Para isso, basta ir ao menu da ferramenta e selecionar o\u00a0modo de design.<\/li>\n<li>Para salvar seu bot\u00e3o criado.\u00a0Voc\u00ea precisa ir ao\u00a0menu\u00a0Arquivo\u00a0e tocar na\u00a0op\u00e7\u00e3o\u00a0&#8220;Salvar&#8221;\u00a0.<\/li>\n<li>\u00e9\u00a0hora de verificar se est\u00e1 funcionando ou n\u00e3o.\u00a0Ent\u00e3o, toque no bot\u00e3o criado e voc\u00ea ver\u00e1 que ele executar\u00e1 a consulta.\u00a0E muito em breve voc\u00ea estar\u00e1 no bot\u00e3o para\u00a0exportar dados automaticamente para o Excel.<\/li>\n<\/ol>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 3 # Exportando dados do relat\u00f3rio\u00a0para o\u00a0Excel<\/u><\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1304\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-report-to-excel.png\" alt=\"Exportando dados do relat\u00f3rio\u00a0para o\u00a0Excel\" width=\"301\" height=\"284\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-report-to-excel.png 301w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-report-to-excel-300x283.png 300w\" sizes=\"auto, (max-width: 301px) 100vw, 301px\" \/><\/p>\n<p style=\"text-align: justify;\">Antes de\u00a0iniciar o processo de exporta\u00e7\u00e3o de dados para o Excel, basta verificar se as configura\u00e7\u00f5es de exporta\u00e7\u00e3o do Excel est\u00e3o configuradas\u00a0adequadamente ou n\u00e3o.<\/p>\n<p style=\"text-align: justify;\"><strong><u>Definindo configura\u00e7\u00f5es de exporta\u00e7\u00e3o do Excel<\/u><\/strong><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea tem permiss\u00e3o para escolher o formato de arquivo do Excel para o qual o relat\u00f3rio ser\u00e1 exportado.\u00a0Pode ser tamb\u00e9m.\u00a0csv\u00a0ou .xml.\u00a0Suponha, se voc\u00ea estiver escolhendo.\u00a0csv\u00a0, voc\u00ea pode selecionar o caractere usado como um separador nos arquivos CSV exportados.<\/p>\n<p style=\"text-align: justify;\"><strong>Aqui est\u00e3o as etapas para definir a configura\u00e7\u00e3o da exporta\u00e7\u00e3o do Excel:<\/strong><\/p>\n<ol style=\"text-align: justify;\">\n<li>Selecione o\u00a0\u00edcone<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1316 alignnone\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Settings_cog_icon_rn3.png\" alt=\"Settings_cog_icon_rn3\" width=\"44\" height=\"44\" \/>presente no canto superior direito da p\u00e1gina. Depois, escolha a <strong>op\u00e7\u00e3o Configura\u00e7\u00f5es.<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1302\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Exporting-Report-Data-To-Excel-1.png\" alt=\"Exportando dados do relat\u00f3rio\u00a0para o\u00a0Excel 1\" width=\"136\" height=\"163\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"2\">\n<li>Agora, no campo\u00a0<strong>Report Export Export Format\u00a0<\/strong>, selecione o apropriado\u00a0<em>Suponha que\u00a0voc\u00ea esteja usando o\u00a0<\/em>Excel XP ou as vers\u00f5es mais recentes e escolha o\u00a0<em>formato .xml\u00a0<\/em>.\u00a0Mas se voc\u00ea estiver usando uma vers\u00e3o antiga do Excel, selecione o.\u00a0formato\u00a0<em>csv\u00a0<\/em>.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1303\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Exporting-Report-Data-To-Excel-2.png\" alt=\"Exportando dados do relat\u00f3rio\u00a0para o\u00a0Excel 2\" width=\"449\" height=\"112\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Exporting-Report-Data-To-Excel-2.png 449w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Exporting-Report-Data-To-Excel-2-300x75.png 300w\" sizes=\"auto, (max-width: 449px) 100vw, 449px\" \/><\/p>\n<ol style=\"text-align: justify;\" start=\"3\">\n<li>Suponha que voc\u00ea tenha escolhido o\u00a0<em>.\u00a0csv\u00a0<\/em>Ent\u00e3o\u00a0, nesse caso, inserir o caractere que deve ser usado como separador de campo dentro dos relat\u00f3rios que s\u00e3o exportados para o Excel.\u00a0Por padr\u00e3o, o campo j\u00e1 parece definido aqui \u00e9 v\u00edrgula (,).<\/li>\n<li>Escolha a op\u00e7\u00e3o\u00a0<strong>Compactar anexo de email do Excel\u00a0<\/strong>para compactar os anexos de email e envi\u00e1-lo no formato de arquivo .zip.\u00a0Bem, \u00e9 uma etapa muito \u00fatil para diminuir o tamanho do arquivo de relat\u00f3rios grandes.<\/li>\n<li>Toque na\u00a0op\u00e7\u00e3o\u00a0<strong>Salvar\u00a0<\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\"><strong><em><u>Exportando dados\u00a0para o\u00a0Excel<\/u><\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">Para exportar dados para o Excel, execute as seguintes etapas:<\/p>\n<ol style=\"text-align: justify;\">\n<li>Abra os\u00a0<strong>relat\u00f3rios\u00a0<\/strong>cujos dados voc\u00ea deseja exportar.<\/li>\n<li>No canto superior direito, voc\u00ea ver\u00e1 esse tipo de <strong><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-1299 alignnone\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Excel_export_icon.png\" alt=\"Excel_export_icon\" width=\"44\" height=\"50\" \/> exporta\u00e7\u00e3o do Excel \u00edcone de<\/strong>.\u00a0Ent\u00e3o, toque nele.<\/li>\n<\/ol>\n<p style=\"text-align: justify;\">Voc\u00ea ver\u00e1 que, ap\u00f3s a conclus\u00e3o da etapa, o arquivo do Excel ser\u00e1 gerado.<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>M\u00e9todo 4 # Exportar dados SQL\u00a0para o\u00a0Excel<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1314\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-sql-to-excel.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel\" width=\"476\" height=\"208\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-sql-to-excel.png 960w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-sql-to-excel-300x131.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/export-sql-to-excel-768x336.png 768w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/><\/p>\n<p style=\"text-align: justify;\">Voc\u00ea pode executar a tarefa de\u00a0<strong>Exportar dados do SQL\u00a0para o\u00a0Excel\u00a0<\/strong>usando o\u00a0<strong>Assistente para Importa\u00e7\u00e3o e Exporta\u00e7\u00e3o\u00a0<\/strong>do\u00a0<strong>SQL Server.<\/strong><\/p>\n<p style=\"text-align: justify;\">Este recurso do assistente \u00e9 uma oferta do\u00a0<strong>SQL Server Management Studio (SSMS).\u00a0<\/strong>Usando esse recurso, \u00e9 poss\u00edvel executar facilmente a tarefa de exportar dados SQL para o Excel.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Abra o\u00a0<strong>SSMS\u00a0<\/strong>(SQL Server Management Studio) e conecte-se ao seu banco de dados.<\/li>\n<li>No explorador de objetos, procure o\u00a0<strong>Banco de Dados do Servidor\u00a0<\/strong>no qual voc\u00ea precisa exportar para o Excel.\u00a0Depois de obt\u00ea-lo, toque nele com o bot\u00e3o direito.\u00a0E, em seguida, escolha\u00a0<strong>Tarefas&gt;\u00a0Exportar dados\u00a0<\/strong>para exportar os dados da tabela no SQL.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">\u00a0Depois de fazer isso na tela, o\u00a0<strong>Assistente para Importa\u00e7\u00e3o e Exporta\u00e7\u00e3o do SQL Server\u00a0<\/strong>aparece aberto na tela.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1305\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-1.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 1\" width=\"618\" height=\"500\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-1.png 618w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-1-300x243.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Clique\u00a0no bot\u00e3o suspenso\u00a0<strong>Fonte de dados\u00a0<\/strong>para escolher a fonte de dados que voc\u00ea precisa copiar.\u00a0Nesse menu suspenso, voc\u00ea deve escolher a op\u00e7\u00e3o\u00a0<strong>&#8220;SQL Server Native Client 11.0&#8221;\u00a0<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Na caixa suspensa do\u00a0<strong>nome\u00a0<\/strong>do\u00a0<strong>servidor,\u00a0<\/strong>escolha a\u00a0<strong>inst\u00e2ncia\u00a0<\/strong>do\u00a0<strong>SQL Server\u00a0<\/strong>.\u00a0Visto que, na\u00a0<strong>se\u00e7\u00e3o Autentica\u00e7\u00e3o,\u00a0<\/strong>escolha autentica\u00e7\u00e3o para a conex\u00e3o da fonte de dados.\u00a0Depois disso, na caixa suspensa do banco de dados, selecione o banco de dados do qual voc\u00ea precisa copiar os dados.<\/p>\n<p style=\"text-align: justify;\">Quando tudo\u00a0estiver\u00a0pronto, basta pressionar a\u00a0op\u00e7\u00e3o\u00a0<strong>&#8220;Avan\u00e7ar&#8221;\u00a0<\/strong>.<\/p>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1306\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-2.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 2\" width=\"618\" height=\"569\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-2.png 618w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-2-300x276.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>A pr\u00f3xima janela que voc\u00ea ver\u00e1 na tela \u00e9\u00a0<strong>&#8220;Escolha um destino&#8221;\u00a0<\/strong>. Na caixa aberta,\u00a0<strong>escolha uma\u00a0<\/strong>caixa\u00a0<strong>Destino\u00a0<\/strong>, para as caixas de destino, basta fazer uma sele\u00e7\u00e3o para o\u00a0Depois, atribua a vers\u00e3o e o caminho do arquivo Excel conforme preenchendo todos os dados, toque no\u00a0bot\u00e3o\u00a0<strong>&#8220;Avan\u00e7ar&#8221;\u00a0<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1307\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-3.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 3\" width=\"620\" height=\"571\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-3.png 620w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-3-300x276.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>A pr\u00f3xima janela aberta \u00e9\u00a0<strong>&#8220;Especificar c\u00f3pia ou consulta da tabela\u00a0<\/strong>&#8220;.\u00a0Aqui voc\u00ea deve selecionar a op\u00e7\u00e3o\u00a0<strong>&#8220;Copiar dados de uma ou mais tabelas ou visualiza\u00e7\u00f5es&#8221;.\u00a0<\/strong>Depois, toque no\u00a0bot\u00e3o\u00a0<strong>Avan\u00e7ar\u00a0<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1308\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-4.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 4\" width=\"620\" height=\"567\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-4.png 620w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-4-300x274.png 300w\" sizes=\"auto, (max-width: 620px) 100vw, 620px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na pr\u00f3xima janela aberta de\u00a0<strong>&#8220;Selecionar tabela e exibi\u00e7\u00f5es de origem&#8221;,\u00a0<\/strong>voc\u00ea pode fazer uma sele\u00e7\u00e3o para uma ou mais exibi\u00e7\u00f5es e tabelas das quais deseja\u00a0<strong>exportar dados SQL para o Excel.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1309\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-5.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 5\" width=\"622\" height=\"571\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-5.png 622w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-5-300x275.png 300w\" sizes=\"auto, (max-width: 622px) 100vw, 622px\" \/><\/p>\n<p style=\"text-align: justify;\">Toque na op\u00e7\u00e3o de visualiza\u00e7\u00e3o para obter uma visualiza\u00e7\u00e3o f\u00e1cil dos dados que ser\u00e3o gerados no arquivo do Excel.\u00a0Para avan\u00e7ar para a etapa\u00a0<strong>seguinte,\u00a0<\/strong>escolha a\u00a0<strong>pr\u00f3xima\u00a0<\/strong>op\u00e7\u00e3o.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora na tela, uma janela de\u00a0<strong>\u201cSalvar e Executar Pacote&#8221; \u00e9\u00a0<\/strong> Nesse caso, voc\u00ea deve escolher a op\u00e7\u00e3o\u00a0<strong>&#8220;Executar imediatamente&#8221;\u00a0<\/strong>e pressionar o bot\u00e3o\u00a0<strong>&#8220;Avan\u00e7ar&#8221;\u00a0<\/strong>.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1310\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-6.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 6\" width=\"621\" height=\"573\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-6.png 621w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-6-300x277.png 300w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>A pr\u00f3xima janela que aparece agora \u00e9\u00a0<strong>&#8220;Complete the Wizard&#8221;.\u00a0<\/strong>Nesta janela, voc\u00ea pode fazer uma r\u00e1pida recapitula\u00e7\u00e3o da etapa que voc\u00ea executou at\u00e9 agora. Se voc\u00ea encontrar tudo\u00a0<strong>OK\u00a0<\/strong>, pressione o bot\u00e3o\u00a0<strong>Finish\u00a0<\/strong>Tapping para iniciar a\u00a0<strong>exporta\u00e7\u00e3o.\u00a0De Dados SQL Para\u00a0Excel.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1311\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-7.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 7\" width=\"621\" height=\"569\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-7.png 621w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-7-300x275.png 300w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na pr\u00f3xima janela, voc\u00ea pode assistir ao processo de exporta\u00e7\u00e3o.\u00a0Ap\u00f3s a conclus\u00e3o, toque no bot\u00e3o suspenso presente ao lado de\u00a0<strong>&#8220;Relat\u00f3rio&#8221;.<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1312\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-8.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 8\" width=\"618\" height=\"511\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-8.png 618w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-8-300x248.png 300w\" sizes=\"auto, (max-width: 618px) 100vw, 618px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>No menu suspenso, voc\u00ea deve escolher\u00a0<strong>\u201csalvar relat\u00f3rio em arquivo\u2026\u00a0\u201d (\u00a0<\/strong>com o bloco de notas ou Excel) para salvar o relat\u00f3rio.\u00a0Nesse bloco de notas e no Excel, voc\u00ea precisa escolher o Excel para o arquivo de destino.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1313\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-9.png\" alt=\"Exportar dados SQL\u00a0para o\u00a0Excel 9\" width=\"670\" height=\"243\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-9.png 670w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/Export-SQL-Data-To-Excel-9-300x109.png 300w\" sizes=\"auto, (max-width: 670px) 100vw, 670px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Conclus\u00e3o:<\/u><\/strong><\/h3>\n<p style=\"text-align: justify;\">O Microsoft Excel \u00e9 um arquivo muito crucial e um pequeno erro pode assumir toda a pasta de trabalho do Excel e os dados armazenados nela.\u00a0Portanto, \u00e9 altamente recomend\u00e1vel manipular arquivos do Excel com cuidado e\u00a0<strong><em>fazer backup dos dados do Excel regularmente\u00a0<\/em><\/strong>para evitar a perda de dados no futuro.<\/p>\n<p style=\"text-align: justify;\">Se voc\u00ea tiver alguma d\u00favida adicional sobre a\u00a0<strong>exporta\u00e7\u00e3o de dados para o Excel\u00a0<\/strong>, informe-nos na se\u00e7\u00e3o de coment\u00e1rios abaixo.<\/p>\n<p style=\"text-align: justify;\"><strong><em>Boa sorte\u2026.<\/em><\/strong><\/p>\n<p style=\"text-align: justify;\">\u00a0<br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Resumo: este tutorial ajudar\u00e1 todos dentro explorando seu conhecimento sobre como exportar dados para o Excel. Este artigo aborda quatro &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"4 truques f\u00e1ceis para exportar dados para o Excel\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#more-1317\" aria-label=\"Read more about 4 truques f\u00e1ceis para exportar dados para o Excel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":1318,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[695],"tags":[654,653,650,651,652],"class_list":["post-1317","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutoriais","tag-como-exportar-dados-para-o-excel","tag-exportando-dados-relatorio-para-o-excel","tag-exportar-dados-do-access-para-excel","tag-exportar-dados-para-o-excel","tag-exportar-dados-sql-para-o-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>4 truques f\u00e1ceis para exportar dados para o Excel<\/title>\n<meta name=\"description\" content=\"Experimente 4 m\u00e9todos diferentes para exportar dados para o Excel M\u00e9todo 1: Exportar dados do Access para o Excel; M\u00e9todo 2 # Exportando dados do relat\u00f3rio para o Excel; M\u00e9todo 3 # Exportar dados SQL para Excel\u2026\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"4 truques f\u00e1ceis para exportar dados para o Excel\" \/>\n<meta property=\"og:description\" content=\"Experimente 4 m\u00e9todos diferentes para exportar dados para o Excel M\u00e9todo 1: Exportar dados do Access para o Excel; M\u00e9todo 2 # Exportando dados do relat\u00f3rio para o Excel; M\u00e9todo 3 # Exportar dados SQL para Excel\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-26T13:40:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-07-23T12:28:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/how-to-Export-Data-To-Excel-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"4 truques f\u00e1ceis para exportar dados para o Excel\",\"datePublished\":\"2020-03-26T13:40:11+00:00\",\"dateModified\":\"2021-07-23T12:28:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel\"},\"wordCount\":1884,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/how-to-Export-Data-To-Excel-pt.png\",\"keywords\":[\"como exportar dados para o Excel\",\"Exportando dados relat\u00f3rio para o Excel\",\"Exportar dados do Access para Excel\",\"Exportar dados para o Excel\",\"Exportar dados SQL para o Excel\"],\"articleSection\":[\"Tutoriais\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel\",\"name\":\"4 truques f\u00e1ceis para exportar dados para o Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/how-to-Export-Data-To-Excel-pt.png\",\"datePublished\":\"2020-03-26T13:40:11+00:00\",\"dateModified\":\"2021-07-23T12:28:43+00:00\",\"description\":\"Experimente 4 m\u00e9todos diferentes para exportar dados para o Excel M\u00e9todo 1: Exportar dados do Access para o Excel; M\u00e9todo 2 # Exportando dados do relat\u00f3rio para o Excel; M\u00e9todo 3 # Exportar dados SQL para Excel\u2026\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/how-to-Export-Data-To-Excel-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/03\\\/how-to-Export-Data-To-Excel-pt.png\",\"width\":900,\"height\":450,\"caption\":\"4 truques f\u00e1ceis para exportar dados para o Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/como-exportar-dados-para-o-excel#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"4 truques f\u00e1ceis para exportar dados para o Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"4 truques f\u00e1ceis para exportar dados para o Excel","description":"Experimente 4 m\u00e9todos diferentes para exportar dados para o Excel M\u00e9todo 1: Exportar dados do Access para o Excel; M\u00e9todo 2 # Exportando dados do relat\u00f3rio para o Excel; M\u00e9todo 3 # Exportar dados SQL para Excel\u2026","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel","og_locale":"en_US","og_type":"article","og_title":"4 truques f\u00e1ceis para exportar dados para o Excel","og_description":"Experimente 4 m\u00e9todos diferentes para exportar dados para o Excel M\u00e9todo 1: Exportar dados do Access para o Excel; M\u00e9todo 2 # Exportando dados do relat\u00f3rio para o Excel; M\u00e9todo 3 # Exportar dados SQL para Excel\u2026","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2020-03-26T13:40:11+00:00","article_modified_time":"2021-07-23T12:28:43+00:00","og_image":[{"width":900,"height":450,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/how-to-Export-Data-To-Excel-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"4 truques f\u00e1ceis para exportar dados para o Excel","datePublished":"2020-03-26T13:40:11+00:00","dateModified":"2021-07-23T12:28:43+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel"},"wordCount":1884,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/how-to-Export-Data-To-Excel-pt.png","keywords":["como exportar dados para o Excel","Exportando dados relat\u00f3rio para o Excel","Exportar dados do Access para Excel","Exportar dados para o Excel","Exportar dados SQL para o Excel"],"articleSection":["Tutoriais"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel","url":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel","name":"4 truques f\u00e1ceis para exportar dados para o Excel","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/how-to-Export-Data-To-Excel-pt.png","datePublished":"2020-03-26T13:40:11+00:00","dateModified":"2021-07-23T12:28:43+00:00","description":"Experimente 4 m\u00e9todos diferentes para exportar dados para o Excel M\u00e9todo 1: Exportar dados do Access para o Excel; M\u00e9todo 2 # Exportando dados do relat\u00f3rio para o Excel; M\u00e9todo 3 # Exportar dados SQL para Excel\u2026","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/how-to-Export-Data-To-Excel-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/03\/how-to-Export-Data-To-Excel-pt.png","width":900,"height":450,"caption":"4 truques f\u00e1ceis para exportar dados para o Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/como-exportar-dados-para-o-excel#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"4 truques f\u00e1ceis para exportar dados para o Excel"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=1317"}],"version-history":[{"count":3,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1317\/revisions"}],"predecessor-version":[{"id":3415,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/1317\/revisions\/3415"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/1318"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=1317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=1317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=1317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}